Variables that contain missing values for the entire row are hidden when you generate output using PROC REPORT with the ODS destination for Excel. The problem occurs because the rows that contain all missing values are incorrectly generated with a row height of zero.

To circumvent the problem, do one of the following:

• Modify the row height using the ROW_HEIGHTS= suboption of the OPTIONS option in the ODS EXCEL statement. The sample code on the Full Code tab illustrates this.
• Use a different procedure, such as PROC PRINT, to generate the output. The PRINT procedure displays the output correctly when the sequence of missing values occurs.

Operating System and Release Information

/* The DATA step below generates three observations, where the second observation contains */
/* missing values for the entire row.  Specifying the ROW_HEIGHTS= suboption enables you   */
/* to set the height explicitly for the table body cells.  Specifying a zero for the other */
/* positions allows the values to be taken from the style.                                 */                                                                               */
data one;
   infile cards missover;
   input var1 $ var2 $;
   datalines; 
A A
  
C C
;
run;

ods excel file="c:\test\test1.xlsx" options(row_heights="0,15,0,0,0,0");

proc report data=one;
   define var1 / display;
   define var2 / display;
run;

ods excel close;